<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">  
  <title>视频列表</title>
 </head>
 <body>
 
 <?php
  require_once('inc_admin.php');
  require_once('menu.php');

  connect();
  if(empty($_GET['id'])){
  $sql='select * from videos';
}
else{
  $sql='select * from  videos where vid ='.$_GET['id'];
}

  //编写sql语句
  $sql = 'select * from videos';
  //echo $sql.'<br/>';  
  $result = fetch_array($sql); 
   
 ?>
 <center><h3>视频列表</h3></center>
 <table align="center" width="80%" border=1> 
 <tr>
   <th>编号</th>
   <th>视频名称</th>
   <th>视频类型</th>
   <th>海报</th>
   <th>内容简介</th>
   <th>添加日期</th>
   <th>上传用户</th>
   <th>点击率</th>
   <th>下载量</th>
   <th>下载地址</th>
   

   <th>操作</th>   
   
 </tr>

 <?php
  foreach ($result as $row) {
   echo '<tr>';
   echo '<td>'.$row['vid'].'</td>';
   echo '<td>'.$row['videoname'].'</td>'; 
   if($row['tid']==1)
  {
    $row['tid']='电影';
  }
  if($row['tid']==2)
  {
    $row['tid']='电视剧';
  }
  if($row['tid']==3)
  {
    $row['tid']='动画片';
  }
  if($row['tid']==4)
  {
    $row['tid']='原创';
  }
  if($row['tid']==5)
  {
    $row['tid']='冒险';
  }
   echo '<td>'.$row['tid'].'</td>';
   echo '<td>'.$row['pic'].'</td>'; 
   echo '<td>'.$row['intro'].'</td>';
   echo '<td>'.$row['uploaddate'].'</td>';
   echo '<td>'.$row['uploadadmin'].'</td>';
   echo '<td>'.$row['hittimes'].'</td>';
   echo '<td>'.$row['downtimes'].'</td>';
   echo '<td>'.$row['address'].'</td>';
   
   echo '<td><a href="videoForm.html?id='.$row['vid'].' ">添加</a> |<a href="videoEditForm.php?id='.$row['vid'].' ">修改</a> | 
   <a href="videoDelete.php?id='.$row['vid'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';
   echo '</tr>';  
  }
  echo '</table>';  
  $totalrows = count($result);
  echo "<table align='center'><tr><td>共有{$totalrows}条记录</td></tr></table>";   
 ?>
 
 </body>
</html>